﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace Pacs.DAL
{
	/// <summary>
	/// 数据访问类:XT_SystemLoginInfo
	/// </summary>
	public partial class XT_SystemLoginInfo
	{

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Pacs.Model.XT_SystemLoginInfo GetModelByDengLuMing(string DengLuMing)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 ID,YongHuID,XingMing,DengLuMing,DengLuMiMa,YongHuLeiXing,YongHuJueSeID,ChuangJianShiJian,ZhuangTai,YongHuZuID from XT_SystemLoginInfo ");
            strSql.Append(" where DengLuMing=@DengLuMing ");
            SqlParameter[] parameters = {
					new SqlParameter("@DengLuMing", SqlDbType.VarChar,100)			};
            parameters[0].Value = DengLuMing;

            Pacs.Model.XT_SystemLoginInfo model = new Pacs.Model.XT_SystemLoginInfo();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
	}
}

